Overview

Dataset info

Number of variables75
Number of observations877986
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory502.4 MiB
Average record size in memory600.0 B

Variables types

Numeric47
Categorical13
Boolean3
Date0
URL0
Text (Unique)0
Rejected12
Unsupported0

Warnings

acc_now_delinq has 873344 (99.5%) zeros Zeros
acc_open_past_24mths has 36913 (4.2%) zeros Zeros
annual_inc is highly skewed (γ1 = 481.5767234) Skewed
chargeoff_within_12_mths has 870928 (99.2%) zeros Zeros
collection_recovery_fee has 833279 (94.9%) zeros Zeros
collections_12_mths_ex_med has 860256 (98.0%) zeros Zeros
delinq_2yrs has 699379 (79.7%) zeros Zeros
delinq_amnt is highly skewed (γ1 = 86.71946315) Skewed
delinq_amnt has 873983 (99.5%) zeros Zeros
earliest_cr_line has a high cardinality: 709 distinct values Warning
fico_range_low is highly correlated with fico_range_high (ρ = 0.9999999033) Rejected
funded_amnt_inv is highly correlated with funded_amnt (ρ = 0.9999934741) Rejected
installment is highly correlated with funded_amnt_inv (ρ = 0.9482554488) Rejected
last_fico_range_low has 11866 (1.4%) zeros Zeros
loan_amnt is highly correlated with installment (ρ = 0.9483703021) Rejected
mo_sin_rcnt_rev_tl_op has 13591 (1.5%) zeros Zeros
mo_sin_rcnt_tl has 14028 (1.6%) zeros Zeros
mort_acc has 370578 (42.2%) zeros Zeros
num_accts_ever_120_pd has 666796 (75.9%) zeros Zeros
num_actv_bc_tl has 20219 (2.3%) zeros Zeros
num_bc_sats has 9947 (1.1%) zeros Zeros
num_il_tl has 24904 (2.8%) zeros Zeros
num_rev_tl_bal_gt_0 is highly correlated with num_actv_rev_tl (ρ = 0.9784947354) Rejected
num_tl_30dpd has 874894 (99.6%) zeros Zeros
num_tl_90g_dpd_24m has 828135 (94.3%) zeros Zeros
num_tl_op_past_12m has 163858 (18.7%) zeros Zeros
open_acc is highly correlated with num_sats (ρ = 0.9988132903) Rejected
out_prncp has 345363 (39.3%) zeros Zeros
out_prncp_inv is highly correlated with out_prncp (ρ = 0.9999980186) Rejected
policy_code has constant value "1" Rejected
pub_rec has 718878 (81.9%) zeros Zeros
pub_rec_bankruptcies has 764266 (87.0%) zeros Zeros
recoveries is highly correlated with collection_recovery_fee (ρ = 0.9864791705) Rejected
tax_liens is highly skewed (γ1 = 23.34781072) Skewed
tax_liens has 843069 (96.0%) zeros Zeros
tot_coll_amt is highly skewed (γ1 = 151.083683) Skewed
tot_coll_amt has 729825 (83.1%) zeros Zeros
tot_hi_cred_lim is highly correlated with tot_cur_bal (ρ = 0.972754613) Rejected
total_bc_limit has 10424 (1.2%) zeros Zeros
total_il_high_credit_limit has 94263 (10.7%) zeros Zeros
total_pymnt_inv is highly correlated with total_pymnt (ρ = 0.9999946425) Rejected
total_rec_late_fee is highly skewed (γ1 = 20.29350981) Skewed
total_rec_late_fee has 844499 (96.2%) zeros Zeros
total_rec_prncp is highly correlated with total_pymnt_inv (ρ = 0.9665829516) Rejected

Variables

acc_now_delinq
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.005606011941
Minimum0
Maximum7
Zeros (%)99.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.079666892
Coef of variation14.21097437
Kurtosis396.9390178
Mean0.005606011941
MAD0.01115274479
Skewness16.71443451
Sum4922
Variance0.00634681368
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 873344 99.5%
 
1 4401 0.5%
 
2 213 < 0.1%
 
3 22 < 0.1%
 
4 4 < 0.1%
 
7 1 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 873344 99.5%
 
1 4401 0.5%
 
2 213 < 0.1%
 
3 22 < 0.1%
 
4 4 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 1 < 0.1%
 
6 1 < 0.1%
 
4 4 < 0.1%
 
3 22 < 0.1%
 
2 213 < 0.1%
 

acc_open_past_24mths
Numeric

Distinct count52
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean4.659733754
Minimum0
Maximum61
Zeros (%)4.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q12
Median4
Q36
95-th percentile11
Maximum61
Range61
Interquartile range4

Descriptive statistics

Standard deviation3.262668052
Coef of variation0.7001833633
Kurtosis4.763240446
Mean4.659733754
MAD2.483325368
Skewness1.451089178
Sum4091181
Variance10.64500282
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 29.5 33.5 37.5 47. 61. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 129315 14.7%
 
4 120911 13.8%
 
2 117647 13.4%
 
5 102741 11.7%
 
1 84938 9.7%
 
6 80886 9.2%
 
7 61014 6.9%
 
8 44203 5.0%
 
0 36913 4.2%
 
9 31224 3.6%
 
Other values (42) 68194 7.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 36913 4.2%
 
1 84938 9.7%
 
2 117647 13.4%
 
3 129315 14.7%
 
4 120911 13.8%
 

Maximum 5 values

ValueCountFrequency (%) 
61 1 < 0.1%
 
56 1 < 0.1%
 
55 1 < 0.1%
 
54 2 < 0.1%
 
49 2 < 0.1%
 

addr_state
Categorical

Distinct count50
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
CA
 
117739
TX
 
74295
NY
 
72705
Other values (47)
613247
ValueCountFrequency (%) 
CA 117739 13.4%
 
TX 74295 8.5%
 
NY 72705 8.3%
 
FL 63663 7.3%
 
IL 36022 4.1%
 
NJ 32066 3.7%
 
PA 29547 3.4%
 
OH 29463 3.4%
 
GA 28712 3.3%
 
NC 24375 2.8%
 
Other values (40) 369399 42.1%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

annual_inc
Numeric

Distinct count46617
Unique (%)5.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean79805.0889
Minimum0
Maximum110000000
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile28000
Q147500
Median66000
Q395000
95-th percentile166000
Maximum110000000
Range110000000
Interquartile range47500

Descriptive statistics

Standard deviation154922.5767
Coef of variation1.941261878
Kurtosis316133.8167
Mean79805.0889
MAD35726.73393
Skewness481.5767234
Sum7.006775078e+10
Variance2.400100478e+10
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 1.8000000e-01 1.5000000e+00 1.0750000e+02 8.7500000e+02 ... 1.4940000e+06 1.5040000e+06 5.6108570e+06 1.0286136e+07 1.1000000e+08], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
60000 33974 3.9%
 
50000 29252 3.3%
 
65000 25228 2.9%
 
70000 24271 2.8%
 
80000 23598 2.7%
 
75000 23037 2.6%
 
40000 22726 2.6%
 
45000 20494 2.3%
 
55000 19739 2.2%
 
100000 18679 2.1%
 
Other values (46607) 636988 72.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 550 0.1%
 
0.36 1 < 0.1%
 
1 21 < 0.1%
 
2 1 < 0.1%
 
6 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
110000000 1 < 0.1%
 
61000000 1 < 0.1%
 
10999200 1 < 0.1%
 
9573072 1 < 0.1%
 
9550000 1 < 0.1%
 

application_type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Individual
826772
Joint App
 
51214
ValueCountFrequency (%) 
Individual 826772 94.2%
 
Joint App 51214 5.8%
 
Max length10
Mean length9.941668774
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

chargeoff_within_12_mths
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.008942056024
Minimum0
Maximum9
Zeros (%)99.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.1082632187
Coef of variation12.1071953
Kurtosis617.3394845
Mean0.008942056024
MAD0.01774034431
Skewness18.28569017
Sum7851
Variance0.01172092452
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 870928 99.2%
 
1 6513 0.7%
 
2 405 < 0.1%
 
3 83 < 0.1%
 
4 34 < 0.1%
 
5 11 < 0.1%
 
6 4 < 0.1%
 
9 3 < 0.1%
 
7 3 < 0.1%
 
8 2 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 870928 99.2%
 
1 6513 0.7%
 
2 405 < 0.1%
 
3 83 < 0.1%
 
4 34 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 3 < 0.1%
 
8 2 < 0.1%
 
7 3 < 0.1%
 
6 4 < 0.1%
 
5 11 < 0.1%
 

collection_recovery_fee
Numeric

Distinct count38735
Unique (%)4.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean16.44041308
Minimum0
Maximum7174.719
Zeros (%)94.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile11.6352
Maximum7174.719
Range7174.719
Interquartile range0

Descriptive statistics

Standard deviation101.8510925
Coef of variation6.195166267
Kurtosis315.9564187
Mean16.44041308
MAD31.22513432
Skewness12.73134475
Sum14434452.52
Variance10373.64505
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 1.54100000e-01 8.99999994e-01 8.99999997e-01 3.59999999e+00 ... 1.45857870e+03 2.08460520e+03 2.84027850e+03 4.25406780e+03 7.17471900e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 833279 94.9%
 
9 305 < 0.1%
 
18 300 < 0.1%
 
27 178 < 0.1%
 
36 166 < 0.1%
 
4.5 159 < 0.1%
 
13.5 118 < 0.1%
 
54 114 < 0.1%
 
45 92 < 0.1%
 
72 78 < 0.1%
 
Other values (38725) 43197 4.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 833279 94.9%
 
0.3082 1 < 0.1%
 
0.378 1 < 0.1%
 
0.809999997 1 < 0.1%
 
0.8514 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7174.719 1 < 0.1%
 
6687.6228 1 < 0.1%
 
6584.1372 1 < 0.1%
 
5510.133 1 < 0.1%
 
5381.1288 1 < 0.1%
 

collections_12_mths_ex_med
Numeric

Distinct count14
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.02221561619
Minimum0
Maximum20
Zeros (%)98.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum20
Range20
Interquartile range0

Descriptive statistics

Standard deviation0.1679709665
Coef of variation7.560941142
Kurtosis488.6881999
Mean0.02221561619
MAD0.04353399058
Skewness12.92177996
Sum19505
Variance0.02821424558
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=14)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 5.5 7.5 20. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 860256 98.0%
 
1 16410 1.9%
 
2 1086 0.1%
 
3 136 < 0.1%
 
4 52 < 0.1%
 
5 21 < 0.1%
 
6 10 < 0.1%
 
7 6 < 0.1%
 
9 3 < 0.1%
 
12 2 < 0.1%
 
Other values (4) 4 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 860256 98.0%
 
1 16410 1.9%
 
2 1086 0.1%
 
3 136 < 0.1%
 
4 52 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
20 1 < 0.1%
 
12 2 < 0.1%
 
11 1 < 0.1%
 
10 1 < 0.1%
 
9 3 < 0.1%
 

debt_settlement_flag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
867536
Y
 
10450
ValueCountFrequency (%) 
N 867536 98.8%
 
Y 10450 1.2%
 

delinq_2yrs
Numeric

Distinct count32
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.3430248318
Minimum0
Maximum42
Zeros (%)79.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum42
Range42
Interquartile range0

Descriptive statistics

Standard deviation0.9318478553
Coef of variation2.716560927
Kurtosis61.73846831
Mean0.3430248318
MAD0.5464879027
Skewness5.672934529
Sum301171
Variance0.8683404254
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=32)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 12.5 14.5 16.5 21.5 42. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 699379 79.7%
 
1 117081 13.3%
 
2 34949 4.0%
 
3 13136 1.5%
 
4 5875 0.7%
 
5 2981 0.3%
 
6 1728 0.2%
 
7 1005 0.1%
 
8 593 0.1%
 
9 399 < 0.1%
 
Other values (22) 860 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 699379 79.7%
 
1 117081 13.3%
 
2 34949 4.0%
 
3 13136 1.5%
 
4 5875 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 < 0.1%
 
36 1 < 0.1%
 
32 1 < 0.1%
 
30 1 < 0.1%
 
29 1 < 0.1%
 

delinq_amnt
Numeric

Distinct count1817
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean19.69888244
Minimum0
Maximum249925
Zeros (%)99.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum249925
Range249925
Interquartile range0

Descriptive statistics

Standard deviation942.7004631
Coef of variation47.85553017
Kurtosis11740.37531
Mean19.69888244
MAD39.2215967
Skewness86.71946315
Sum17295343
Variance888684.1631
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 2.45000e+01 2.55000e+01 2.65000e+01 ... 3.07525e+04 4.79340e+04 6.44565e+04 6.53090e+04 2.49925e+05], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 873983 99.5%
 
25 88 < 0.1%
 
65000 75 < 0.1%
 
57 37 < 0.1%
 
30 36 < 0.1%
 
54 34 < 0.1%
 
53 34 < 0.1%
 
50 33 < 0.1%
 
56 31 < 0.1%
 
35 28 < 0.1%
 
Other values (1807) 3607 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 873983 99.5%
 
1 7 < 0.1%
 
2 9 < 0.1%
 
3 8 < 0.1%
 
4 11 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
249925 1 < 0.1%
 
185408 1 < 0.1%
 
138474 1 < 0.1%
 
130778 1 < 0.1%
 
112524 1 < 0.1%
 

df_index
Numeric

Distinct count133887
Unique (%)15.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean55619.21042
Minimum0
Maximum133886
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile5487
Q127437
Median54874
Q382311
95-th percentile110445
Maximum133886
Range133886
Interquartile range54874

Descriptive statistics

Standard deviation33005.8217
Coef of variation0.5934248518
Kurtosis-0.9813619468
Mean55619.21042
MAD28187.71313
Skewness0.1430938585
Sum4.883288808e+10
Variance1089384266
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 96778.5 97853.5 99119.5 103545.5 105450.5 118647.5 122700.5 133886. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 8 < 0.1%
 
67301 8 < 0.1%
 
65242 8 < 0.1%
 
63195 8 < 0.1%
 
52956 8 < 0.1%
 
50909 8 < 0.1%
 
57054 8 < 0.1%
 
55007 8 < 0.1%
 
77536 8 < 0.1%
 
75489 8 < 0.1%
 
Other values (133877) 877906 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 8 < 0.1%
 
1 8 < 0.1%
 
2 8 < 0.1%
 
3 8 < 0.1%
 
4 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
133886 1 < 0.1%
 
133885 1 < 0.1%
 
133884 1 < 0.1%
 
133883 1 < 0.1%
 
133882 1 < 0.1%
 

disbursement_method
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Cash
871222
DirectPay
 
6764
ValueCountFrequency (%) 
Cash 871222 99.2%
 
DirectPay 6764 0.8%
 
Max length9
Mean length4.038519976
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

earliest_cr_line
Categorical

Distinct count709
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Sep-05
 
6687
Sep-04
 
6650
Aug-04
 
6412
Other values (706)
858237
ValueCountFrequency (%) 
Sep-05 6687 0.8%
 
Sep-04 6650 0.8%
 
Aug-04 6412 0.7%
 
Sep-03 6372 0.7%
 
Aug-05 6356 0.7%
 
Aug-03 6303 0.7%
 
Aug-06 6091 0.7%
 
Oct-03 5965 0.7%
 
Oct-04 5911 0.7%
 
Aug-02 5717 0.7%
 
Other values (699) 815522 92.9%
 
Max length6
Mean length6
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

fico_range_high
Numeric

Distinct count38
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean701.8635081
Minimum664
Maximum850
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum664
5-th percentile664
Q1674
Median694
Q3719
95-th percentile769
Maximum850
Range186
Interquartile range45

Descriptive statistics

Standard deviation32.93544331
Coef of variation0.04692570982
Kurtosis1.438569926
Mean701.8635081
MAD25.74123018
Skewness1.226548943
Sum616226334
Variance1084.743426
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=38)
Histogram
Histogram with variable size bins (bins=[664. 666.5 676.5 686.5 691.5 ... 826.5 831.5 836.5 841.5 850. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
664 77523 8.8%
 
669 73290 8.3%
 
674 72175 8.2%
 
684 65119 7.4%
 
679 64462 7.3%
 
689 56694 6.5%
 
694 55524 6.3%
 
699 49706 5.7%
 
704 47826 5.4%
 
709 43060 4.9%
 
Other values (28) 272607 31.0%
 

Minimum 5 values

ValueCountFrequency (%) 
664 77523 8.8%
 
669 73290 8.3%
 
674 72175 8.2%
 
679 64462 7.3%
 
684 65119 7.4%
 

Maximum 5 values

ValueCountFrequency (%) 
850 185 < 0.1%
 
844 256 < 0.1%
 
839 347 < 0.1%
 
834 587 0.1%
 
829 862 0.1%
 

fico_range_low
Highly correlated

This variable is highly correlated with fico_range_high and should be ignored for analysis

Correlation0.9999999033

funded_amnt
Numeric

Distinct count1560
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean14790.09776
Minimum1000
Maximum40000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1000
5-th percentile3000
Q17500
Median12000
Q320000
95-th percentile35000
Maximum40000
Range39000
Interquartile range12500

Descriptive statistics

Standard deviation9321.148083
Coef of variation0.6302289702
Kurtosis-0.1175966129
Mean14790.09776
MAD7563.617806
Skewness0.8038443875
Sum1.298549878e+10
Variance86883801.58
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1000. 1012.5 1087.5 1112.5 1187.5 ... 39212.5 39587.5 39612.5 39987.5 40000. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
10000 69756 7.9%
 
20000 48229 5.5%
 
12000 47703 5.4%
 
15000 45620 5.2%
 
5000 36217 4.1%
 
35000 32655 3.7%
 
8000 31928 3.6%
 
6000 30539 3.5%
 
16000 27569 3.1%
 
30000 24035 2.7%
 
Other values (1550) 483735 55.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1000 4495 0.5%
 
1025 16 < 0.1%
 
1050 24 < 0.1%
 
1075 9 < 0.1%
 
1100 108 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
40000 13052 1.5%
 
39975 7 < 0.1%
 
39950 3 < 0.1%
 
39925 5 < 0.1%
 
39900 8 < 0.1%
 

funded_amnt_inv
Highly correlated

This variable is highly correlated with funded_amnt and should be ignored for analysis

Correlation0.9999934741

grade
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
C
277322
B
267639
A
149643
Other values (4)
183382
ValueCountFrequency (%) 
C 277322 31.6%
 
B 267639 30.5%
 
A 149643 17.0%
 
D 115824 13.2%
 
E 45974 5.2%
 
F 15576 1.8%
 
G 6008 0.7%
 
Max length1
Mean length1
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

hardship_flag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
877038
Y
 
948
ValueCountFrequency (%) 
N 877038 99.9%
 
Y 948 0.1%
 

home_ownership
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
MORTGAGE
428639
RENT
343387
OWN
105451
Other values (2)
 
509
ValueCountFrequency (%) 
MORTGAGE 428639 48.8%
 
RENT 343387 39.1%
 
OWN 105451 12.0%
 
ANY 505 0.1%
 
NONE 4 < 0.1%
 
Max length8
Mean length5.832147665
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

initial_list_status
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
w
677742
f
200244
ValueCountFrequency (%) 
w 677742 77.2%
 
f 200244 22.8%
 
Max length1
Mean length1
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

installment
Highly correlated

This variable is highly correlated with funded_amnt_inv and should be ignored for analysis

Correlation0.9482554488

int_rate
Numeric

Distinct count170
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.14438129
Minimum5.32
Maximum30.99
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.32
5-th percentile6.49
Q19.49
Median12.62
Q315.59
95-th percentile23.88
Maximum30.99
Range25.67
Interquartile range6.1

Descriptive statistics

Standard deviation5.06407089
Coef of variation0.3852650634
Kurtosis1.059300223
Mean13.14438129
MAD3.886553356
Skewness0.973944813
Sum11540582.75
Variance25.64481398
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 5.32 5.66 6.04 6.16 6.365 ... 30.745 30.77 30.815 30.965 30.99 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5.32 34988 4.0%
 
11.99 34292 3.9%
 
11.49 28896 3.3%
 
13.99 23957 2.7%
 
13.49 23235 2.6%
 
16.02 20509 2.3%
 
12.74 19990 2.3%
 
12.62 19663 2.2%
 
10.42 19235 2.2%
 
9.44 18919 2.2%
 
Other values (160) 634302 72.2%
 

Minimum 5 values

ValueCountFrequency (%) 
5.32 34988 4.0%
 
6 274 < 0.1%
 
6.08 2670 0.3%
 
6.24 9 < 0.1%
 
6.49 6416 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
30.99 792 0.1%
 
30.94 708 0.1%
 
30.89 655 0.1%
 
30.84 667 0.1%
 
30.79 1085 0.1%
 

issue_d
Categorical

Distinct count24
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Mar-16
 
61992
Aug-17
 
43573
Nov-17
 
42343
Other values (21)
730078
ValueCountFrequency (%) 
Mar-16 61992 7.1%
 
Aug-17 43573 5.0%
 
Nov-17 42343 4.8%
 
Sep-17 39713 4.5%
 
Feb-16 39529 4.5%
 
Jul-17 39415 4.5%
 
Dec-17 38154 4.3%
 
Oct-17 38151 4.3%
 
Jun-17 38087 4.3%
 
May-17 37681 4.3%
 
Other values (14) 459348 52.3%
 
Max length6
Mean length6
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

last_fico_range_high
Numeric

Distinct count72
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean688.4523364
Minimum0
Maximum850
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile544
Q1659
Median699
Q3729
95-th percentile789
Maximum850
Range850
Interquartile range70

Descriptive statistics

Standard deviation68.32214293
Coef of variation0.09924019329
Kurtosis0.7346573402
Mean688.4523364
MAD51.36481061
Skewness-0.7675556368
Sum604451513
Variance4667.915215
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 249.5 501.5 506.5 511.5 ... 831.5 836.5 841.5 847. 850. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
694 35363 4.0%
 
699 34749 4.0%
 
704 34453 3.9%
 
709 34035 3.9%
 
684 33883 3.9%
 
714 33108 3.8%
 
689 33065 3.8%
 
719 31941 3.6%
 
724 30783 3.5%
 
679 29984 3.4%
 
Other values (62) 546622 62.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 22 < 0.1%
 
499 11844 1.3%
 
504 2518 0.3%
 
509 2859 0.3%
 
514 3276 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
850 102 < 0.1%
 
844 275 < 0.1%
 
839 461 0.1%
 
834 1014 0.1%
 
829 1738 0.2%
 

last_fico_range_low
Numeric

Distinct count71
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean677.774788
Minimum0
Maximum845
Zeros (%)1.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile540
Q1655
Median695
Q3725
95-th percentile785
Maximum845
Range845
Interquartile range70

Descriptive statistics

Standard deviation102.2677072
Coef of variation0.1508874467
Kurtosis23.58245973
Mean677.774788
MAD59.34179145
Skewness-3.990956813
Sum595076775
Variance10458.68394
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 250. 502.5 507.5 512.5 ... 822.5 827.5 832.5 837.5 845. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
690 35363 4.0%
 
695 34749 4.0%
 
700 34453 3.9%
 
705 34035 3.9%
 
680 33883 3.9%
 
710 33108 3.8%
 
685 33065 3.8%
 
715 31941 3.6%
 
720 30783 3.5%
 
675 29984 3.4%
 
Other values (61) 546622 62.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 11866 1.4%
 
500 2518 0.3%
 
505 2859 0.3%
 
510 3276 0.4%
 
515 3536 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
845 102 < 0.1%
 
840 275 < 0.1%
 
835 461 0.1%
 
830 1014 0.1%
 
825 1738 0.2%
 

last_pymnt_amnt
Numeric

Distinct count291190
Unique (%)33.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3223.427883
Minimum0
Maximum42192.05
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile106.95
Q1288.5
Median526.63
Q32412.48
95-th percentile17267.5325
Maximum42192.05
Range42192.05
Interquartile range2123.98

Descriptive statistics

Standard deviation6144.658282
Coef of variation1.906249652
Kurtosis7.925814539
Mean3223.427883
MAD4121.576768
Skewness2.7438481
Sum2830124554
Variance37756825.4
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 1.5000000e-02 1.0500000e-01 9.9500000e-01 ... 4.0022725e+04 4.0103170e+04 4.0759730e+04 4.1443535e+04 4.2192050e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
301.15 2046 0.2%
 
332.1 1791 0.2%
 
329.72 1518 0.2%
 
361.38 1419 0.2%
 
602.3 1394 0.2%
 
451.73 1377 0.2%
 
324.65 1322 0.2%
 
320.05 1265 0.1%
 
326.97 1259 0.1%
 
335.12 1200 0.1%
 
Other values (291180) 863395 98.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1182 0.1%
 
0.01 68 < 0.1%
 
0.02 12 < 0.1%
 
0.03 6 < 0.1%
 
0.04 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
42192.05 1 < 0.1%
 
42148.53 1 < 0.1%
 
42005.2 1 < 0.1%
 
41453.07 1 < 0.1%
 
41434 1 < 0.1%
 

loan_amnt
Highly correlated

This variable is highly correlated with installment and should be ignored for analysis

Correlation0.9483703021

loan_status
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Current
503359
Fully Paid
264241
Charged Off
 
80804
Other values (4)
 
29582
ValueCountFrequency (%) 
Current 503359 57.3%
 
Fully Paid 264241 30.1%
 
Charged Off 80804 9.2%
 
Late (31-120 days) 16259 1.9%
 
In Grace Period 8052 0.9%
 
Late (16-30 days) 4505 0.5%
 
Default 766 0.1%
 
Max length18
Mean length8.599403635
Min length7
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

mo_sin_old_rev_tl_op
Numeric

Distinct count744
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean182.3199618
Minimum1
Maximum999
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile47
Q1117
Median164
Q3234
95-th percentile372
Maximum999
Range998
Interquartile range117

Descriptive statistics

Standard deviation98.46138068
Coef of variation0.5400471769
Kurtosis1.282080379
Mean182.3199618
MAD76.15936788
Skewness0.9804793666
Sum160074374
Variance9694.643484
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 4.5 7.5 11.5 12.5 ... 649.5 694.5 733. 819. 999. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
132 5265 0.6%
 
125 5226 0.6%
 
130 5211 0.6%
 
129 5179 0.6%
 
136 5171 0.6%
 
133 5128 0.6%
 
126 5120 0.6%
 
135 5109 0.6%
 
127 5101 0.6%
 
124 5096 0.6%
 
Other values (734) 826380 94.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 < 0.1%
 
2 2 < 0.1%
 
3 3 < 0.1%
 
4 5 < 0.1%
 
5 14 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
999 1 < 0.1%
 
901 1 < 0.1%
 
852 1 < 0.1%
 
836 1 < 0.1%
 
821 1 < 0.1%
 

mo_sin_rcnt_rev_tl_op
Numeric

Distinct count292
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.91459773
Minimum0
Maximum547
Zeros (%)1.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q14
Median8
Q317
95-th percentile45
Maximum547
Range547
Interquartile range13

Descriptive statistics

Standard deviation17.57807197
Coef of variation1.263282799
Kurtosis23.2576125
Mean13.91459773
MAD11.05273815
Skewness3.709751662
Sum12216822
Variance308.9886141
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 2.165e+02 2.675e+02 2.970e+02 3.945e+02 5.470e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 67436 7.7%
 
3 65754 7.5%
 
4 60102 6.8%
 
1 54709 6.2%
 
5 53896 6.1%
 
6 47462 5.4%
 
7 43812 5.0%
 
8 39313 4.5%
 
9 34521 3.9%
 
10 31111 3.5%
 
Other values (282) 379870 43.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 13591 1.5%
 
1 54709 6.2%
 
2 67436 7.7%
 
3 65754 7.5%
 
4 60102 6.8%
 

Maximum 5 values

ValueCountFrequency (%) 
547 1 < 0.1%
 
438 1 < 0.1%
 
396 1 < 0.1%
 
393 1 < 0.1%
 
373 1 < 0.1%
 

mo_sin_rcnt_tl
Numeric

Distinct count202
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.159731476
Minimum0
Maximum314
Zeros (%)1.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q13
Median6
Q310
95-th percentile23
Maximum314
Range314
Interquartile range7

Descriptive statistics

Standard deviation8.993482465
Coef of variation1.102178729
Kurtosis48.98798084
Mean8.159731476
MAD5.623877314
Skewness4.76692686
Sum7164130
Variance80.88272686
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 126.5 136.5 150.5 184.5 314. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 95240 10.8%
 
3 93410 10.6%
 
4 83093 9.5%
 
5 71489 8.1%
 
1 71478 8.1%
 
6 61160 7.0%
 
7 54360 6.2%
 
8 45881 5.2%
 
9 37987 4.3%
 
10 32700 3.7%
 
Other values (192) 231188 26.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 14028 1.6%
 
1 71478 8.1%
 
2 95240 10.8%
 
3 93410 10.6%
 
4 83093 9.5%
 

Maximum 5 values

ValueCountFrequency (%) 
314 1 < 0.1%
 
289 1 < 0.1%
 
283 1 < 0.1%
 
272 1 < 0.1%
 
268 1 < 0.1%
 

mort_acc
Numeric

Distinct count39
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.484670598
Minimum0
Maximum94
Zeros (%)42.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile5
Maximum94
Range94
Interquartile range2

Descriptive statistics

Standard deviation1.808425371
Coef of variation1.218065053
Kurtosis14.8338169
Mean1.484670598
MAD1.433236482
Skewness1.842605622
Sum1303520
Variance3.270402321
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=39)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 17.5 19.5 23.5 32. 94. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 370578 42.2%
 
1 162986 18.6%
 
2 133820 15.2%
 
3 92167 10.5%
 
4 56990 6.5%
 
5 31032 3.5%
 
6 15803 1.8%
 
7 7411 0.8%
 
8 3544 0.4%
 
9 1700 0.2%
 
Other values (29) 1955 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 370578 42.2%
 
1 162986 18.6%
 
2 133820 15.2%
 
3 92167 10.5%
 
4 56990 6.5%
 

Maximum 5 values

ValueCountFrequency (%) 
94 1 < 0.1%
 
61 1 < 0.1%
 
51 1 < 0.1%
 
45 1 < 0.1%
 
41 1 < 0.1%
 

num_accts_ever_120_pd
Numeric

Distinct count42
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.5359128733
Minimum0
Maximum51
Zeros (%)75.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile3
Maximum51
Range51
Interquartile range0

Descriptive statistics

Standard deviation1.428509243
Coef of variation2.665562471
Kurtosis53.77908784
Mean0.5359128733
MAD0.8140097001
Skewness5.512583888
Sum470524
Variance2.040638657
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=42)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 18.5 23.5 30.5 37. 51. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 666796 75.9%
 
1 112092 12.8%
 
2 44275 5.0%
 
3 20746 2.4%
 
4 12252 1.4%
 
5 7182 0.8%
 
6 4835 0.6%
 
7 3067 0.3%
 
8 2043 0.2%
 
9 1318 0.2%
 
Other values (32) 3380 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 666796 75.9%
 
1 112092 12.8%
 
2 44275 5.0%
 
3 20746 2.4%
 
4 12252 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
51 1 < 0.1%
 
45 1 < 0.1%
 
42 1 < 0.1%
 
39 1 < 0.1%
 
38 1 < 0.1%
 

num_actv_bc_tl
Numeric

Distinct count39
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.662168873
Minimum0
Maximum47
Zeros (%)2.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q12
Median3
Q35
95-th percentile8
Maximum47
Range47
Interquartile range3

Descriptive statistics

Standard deviation2.361752043
Coef of variation0.64490528
Kurtosis5.052618239
Mean3.662168873
MAD1.777100994
Skewness1.548370467
Sum3215333
Variance5.57787271
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=39)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 21.5 24.5 27.5 34. 47. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 182286 20.8%
 
2 180084 20.5%
 
4 140458 16.0%
 
1 107452 12.2%
 
5 94053 10.7%
 
6 59411 6.8%
 
7 36316 4.1%
 
8 22131 2.5%
 
0 20219 2.3%
 
9 13564 1.5%
 
Other values (29) 22012 2.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 20219 2.3%
 
1 107452 12.2%
 
2 180084 20.5%
 
3 182286 20.8%
 
4 140458 16.0%
 

Maximum 5 values

ValueCountFrequency (%) 
47 1 < 0.1%
 
46 1 < 0.1%
 
37 1 < 0.1%
 
36 2 < 0.1%
 
35 1 < 0.1%
 

num_actv_rev_tl
Numeric

Distinct count55
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.614002957
Minimum0
Maximum63
Zeros (%)0.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile2
Q13
Median5
Q37
95-th percentile12
Maximum63
Range63
Interquartile range4

Descriptive statistics

Standard deviation3.455828121
Coef of variation0.6155729071
Kurtosis5.583865027
Mean5.614002957
MAD2.577306607
Skewness1.661646067
Sum4929016
Variance11.942748
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 32.5 36.5 38.5 47.5 63. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
4 133167 15.2%
 
3 125512 14.3%
 
5 119633 13.6%
 
6 97309 11.1%
 
2 89816 10.2%
 
7 74645 8.5%
 
8 55078 6.3%
 
9 40200 4.6%
 
1 35761 4.1%
 
10 28687 3.3%
 
Other values (45) 78178 8.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4515 0.5%
 
1 35761 4.1%
 
2 89816 10.2%
 
3 125512 14.3%
 
4 133167 15.2%
 

Maximum 5 values

ValueCountFrequency (%) 
63 1 < 0.1%
 
60 1 < 0.1%
 
59 1 < 0.1%
 
57 2 < 0.1%
 
52 1 < 0.1%
 

num_bc_sats
Numeric

Distinct count53
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean4.779800589
Minimum0
Maximum71
Zeros (%)1.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q13
Median4
Q36
95-th percentile11
Maximum71
Range71
Interquartile range3

Descriptive statistics

Standard deviation3.131138976
Coef of variation0.6550773233
Kurtosis7.152841703
Mean4.779800589
MAD2.302844194
Skewness1.825918374
Sum4196598
Variance9.804031285
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 31.5 37.5 43.5 49.5 71. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 151517 17.3%
 
4 140413 16.0%
 
2 124712 14.2%
 
5 112536 12.8%
 
6 83385 9.5%
 
1 62847 7.2%
 
7 58886 6.7%
 
8 40786 4.6%
 
9 27942 3.2%
 
10 19214 2.2%
 
Other values (43) 55748 6.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 9947 1.1%
 
1 62847 7.2%
 
2 124712 14.2%
 
3 151517 17.3%
 
4 140413 16.0%
 

Maximum 5 values

ValueCountFrequency (%) 
71 1 < 0.1%
 
61 1 < 0.1%
 
54 2 < 0.1%
 
50 1 < 0.1%
 
49 2 < 0.1%
 

num_bc_tl
Numeric

Distinct count70
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean7.431093434
Minimum0
Maximum79
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile2
Q14
Median6
Q310
95-th percentile16
Maximum79
Range79
Interquartile range6

Descriptive statistics

Standard deviation4.595423158
Coef of variation0.618404707
Kurtosis4.458419851
Mean7.431093434
MAD3.481089097
Skewness1.501674051
Sum6524396
Variance21.117914
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 39.5 43.5 46.5 58.5 79. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5 96280 11.0%
 
4 94939 10.8%
 
6 90906 10.4%
 
7 81645 9.3%
 
3 79440 9.0%
 
8 70915 8.1%
 
9 58673 6.7%
 
2 53503 6.1%
 
10 48059 5.5%
 
11 38819 4.4%
 
Other values (60) 164807 18.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2667 0.3%
 
1 21873 2.5%
 
2 53503 6.1%
 
3 79440 9.0%
 
4 94939 10.8%
 

Maximum 5 values

ValueCountFrequency (%) 
79 1 < 0.1%
 
77 1 < 0.1%
 
76 1 < 0.1%
 
70 1 < 0.1%
 
68 2 < 0.1%
 

num_il_tl
Numeric

Distinct count112
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.520999196
Minimum0
Maximum159
Zeros (%)2.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q13
Median7
Q311
95-th percentile23
Maximum159
Range159
Interquartile range8

Descriptive statistics

Standard deviation7.446642019
Coef of variation0.8739165265
Kurtosis8.241121241
Mean8.520999196
MAD5.367975128
Skewness2.14446278
Sum7481318
Variance55.45247736
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 ... 66.5 76.5 82.5 98.5 159. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
4 76373 8.7%
 
3 75974 8.7%
 
5 72546 8.3%
 
2 68555 7.8%
 
6 66923 7.6%
 
7 59971 6.8%
 
8 52213 5.9%
 
1 51848 5.9%
 
9 44726 5.1%
 
10 38797 4.4%
 
Other values (102) 270060 30.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 24904 2.8%
 
1 51848 5.9%
 
2 68555 7.8%
 
3 75974 8.7%
 
4 76373 8.7%
 

Maximum 5 values

ValueCountFrequency (%) 
159 1 < 0.1%
 
140 1 < 0.1%
 
138 1 < 0.1%
 
128 1 < 0.1%
 
127 1 < 0.1%
 

num_op_rev_tl
Numeric

Distinct count75
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.224300843
Minimum0
Maximum91
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile3
Q15
Median7
Q310
95-th percentile17
Maximum91
Range91
Interquartile range5

Descriptive statistics

Standard deviation4.770680929
Coef of variation0.5800713058
Kurtosis5.063712718
Mean8.224300843
MAD3.582973114
Skewness1.575254967
Sum7220821
Variance22.75939653
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 43.5 49.5 56.5 63.5 91. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6 94499 10.8%
 
5 92995 10.6%
 
7 87414 10.0%
 
4 82774 9.4%
 
8 77700 8.8%
 
9 66481 7.6%
 
3 61479 7.0%
 
10 55117 6.3%
 
11 45020 5.1%
 
12 36390 4.1%
 
Other values (65) 178117 20.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 468 0.1%
 
1 7786 0.9%
 
2 33332 3.8%
 
3 61479 7.0%
 
4 82774 9.4%
 

Maximum 5 values

ValueCountFrequency (%) 
91 2 < 0.1%
 
86 1 < 0.1%
 
79 1 < 0.1%
 
77 1 < 0.1%
 
76 1 < 0.1%
 

num_rev_accts
Numeric

Distinct count104
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.67560417
Minimum2
Maximum143
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile4
Q18
Median12
Q318
95-th percentile29
Maximum143
Range141
Interquartile range10

Descriptive statistics

Standard deviation7.997535897
Coef of variation0.5848031136
Kurtosis3.863724513
Mean13.67560417
MAD6.089612815
Skewness1.435779548
Sum12006989
Variance63.96058042
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 2. 3.5 4.5 5.5 6.5 ... 71.5 77.5 92.5 107.5 143. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
9 54275 6.2%
 
10 54031 6.2%
 
8 53939 6.1%
 
11 52226 5.9%
 
7 51351 5.8%
 
12 49175 5.6%
 
6 46661 5.3%
 
13 45882 5.2%
 
14 42423 4.8%
 
5 39796 4.5%
 
Other values (94) 388227 44.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2 9580 1.1%
 
3 19643 2.2%
 
4 30376 3.5%
 
5 39796 4.5%
 
6 46661 5.3%
 

Maximum 5 values

ValueCountFrequency (%) 
143 1 < 0.1%
 
128 1 < 0.1%
 
127 1 < 0.1%
 
113 1 < 0.1%
 
112 1 < 0.1%
 

num_rev_tl_bal_gt_0
Highly correlated

This variable is highly correlated with num_actv_rev_tl and should be ignored for analysis

Correlation0.9784947354

num_sats
Numeric

Distinct count82
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean11.698092
Minimum0
Maximum97
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile5
Q18
Median11
Q315
95-th percentile23
Maximum97
Range97
Interquartile range7

Descriptive statistics

Standard deviation5.755076867
Coef of variation0.4919671403
Kurtosis3.525718532
Mean11.698092
MAD4.378381923
Skewness1.341133268
Sum10270761
Variance33.12090975
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 47.5 52.5 57.5 66. 97. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
9 74825 8.5%
 
8 72680 8.3%
 
10 72582 8.3%
 
11 67335 7.7%
 
7 67182 7.7%
 
12 60314 6.9%
 
6 56758 6.5%
 
13 52569 6.0%
 
14 45423 5.2%
 
5 42501 4.8%
 
Other values (72) 265817 30.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 13 < 0.1%
 
1 572 0.1%
 
2 3803 0.4%
 
3 12742 1.5%
 
4 26430 3.0%
 

Maximum 5 values

ValueCountFrequency (%) 
97 1 < 0.1%
 
93 1 < 0.1%
 
91 1 < 0.1%
 
87 1 < 0.1%
 
85 1 < 0.1%
 

num_tl_30dpd
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.003687985913
Minimum0
Maximum4
Zeros (%)99.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.06353409977
Coef of variation17.22731628
Kurtosis411.4624593
Mean0.003687985913
MAD0.007349995894
Skewness18.81592358
Sum3238
Variance0.004036581834
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 874894 99.6%
 
1 2958 0.3%
 
2 123 < 0.1%
 
3 10 < 0.1%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 874894 99.6%
 
1 2958 0.3%
 
2 123 < 0.1%
 
3 10 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
3 10 < 0.1%
 
2 123 < 0.1%
 
1 2958 0.3%
 
0 874894 99.6%
 

num_tl_90g_dpd_24m
Numeric

Distinct count30
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.09083971726
Minimum0
Maximum42
Zeros (%)94.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum42
Range42
Interquartile range0

Descriptive statistics

Standard deviation0.5358187209
Coef of variation5.89850714
Kurtosis359.2630852
Mean0.09083971726
MAD0.1713638925
Skewness14.15839184
Sum79756
Variance0.2871017016
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=30)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 10.5 12.5 15.5 20.5 42. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 828135 94.3%
 
1 37233 4.2%
 
2 7074 0.8%
 
3 2032 0.2%
 
4 1208 0.1%
 
5 661 0.1%
 
6 493 0.1%
 
7 308 < 0.1%
 
8 230 < 0.1%
 
9 171 < 0.1%
 
Other values (20) 441 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 828135 94.3%
 
1 37233 4.2%
 
2 7074 0.8%
 
3 2032 0.2%
 
4 1208 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
42 1 < 0.1%
 
36 1 < 0.1%
 
30 2 < 0.1%
 
29 1 < 0.1%
 
26 1 < 0.1%
 

num_tl_op_past_12m
Numeric

Distinct count33
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.129195682
Minimum0
Maximum32
Zeros (%)18.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median2
Q33
95-th percentile6
Maximum32
Range32
Interquartile range2

Descriptive statistics

Standard deviation1.887244228
Coef of variation0.8863648578
Kurtosis4.866510133
Mean2.129195682
MAD1.420684558
Skewness1.534759941
Sum1869404
Variance3.561690775
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=33)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 14.5 16.5 17.5 21.5 32. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 221442 25.2%
 
2 191442 21.8%
 
0 163858 18.7%
 
3 133569 15.2%
 
4 79041 9.0%
 
5 41617 4.7%
 
6 21479 2.4%
 
7 11988 1.4%
 
8 5930 0.7%
 
9 3279 0.4%
 
Other values (23) 4341 0.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 163858 18.7%
 
1 221442 25.2%
 
2 191442 21.8%
 
3 133569 15.2%
 
4 79041 9.0%
 

Maximum 5 values

ValueCountFrequency (%) 
32 1 < 0.1%
 
31 1 < 0.1%
 
30 1 < 0.1%
 
29 1 < 0.1%
 
28 4 < 0.1%
 

open_acc
Highly correlated

This variable is highly correlated with num_sats and should be ignored for analysis

Correlation0.9988132903

out_prncp
Numeric

Distinct count237959
Unique (%)27.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5457.725306
Minimum0
Maximum38574.22
Zeros (%)39.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2416.34
Q38710.76
95-th percentile21123.9575
Maximum38574.22
Range38574.22
Interquartile range8710.76

Descriptive statistics

Standard deviation7174.495622
Coef of variation1.314557846
Kurtosis1.945575952
Mean5457.725306
MAD5622.233476
Skewness1.545593957
Sum4791806411
Variance51473387.44
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 1.0300000e+00 8.2090000e+01 1.8433500e+02 ... 3.5829885e+04 3.5830210e+04 3.6032125e+04 3.6795180e+04 3.8574220e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 345363 39.3%
 
7237.84 193 < 0.1%
 
1779.11 185 < 0.1%
 
7498.9 169 < 0.1%
 
7526.72 167 < 0.1%
 
7512.78 166 < 0.1%
 
3558.22 162 < 0.1%
 
7456.78 160 < 0.1%
 
6742.07 154 < 0.1%
 
6475.96 151 < 0.1%
 
Other values (237949) 531116 60.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 345363 39.3%
 
0.01 1 < 0.1%
 
0.04 1 < 0.1%
 
0.05 1 < 0.1%
 
0.13 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
38574.22 1 < 0.1%
 
37600 1 < 0.1%
 
37540.29 1 < 0.1%
 
37401.02 1 < 0.1%
 
37340.86 1 < 0.1%
 

out_prncp_inv
Highly correlated

This variable is highly correlated with out_prncp and should be ignored for analysis

Correlation0.9999980186

pct_tl_nvr_dlq
Numeric

Distinct count649
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean93.6745726
Minimum0
Maximum100
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile74.1
Q190.7
Median97.6
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range9.3

Descriptive statistics

Standard deviation9.457127757
Coef of variation0.1009572555
Kurtosis6.629980174
Mean93.6745726
MAD6.886355356
Skewness-2.235874594
Sum82244963.3
Variance89.4372654
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 10.6 16.5 17.05 19.6 ... 98.75 99.05 99.25 99.7 100. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
100 425482 48.5%
 
90 11658 1.3%
 
90.9 10368 1.2%
 
91.7 10205 1.2%
 
88.9 10151 1.2%
 
92.3 9991 1.1%
 
87.5 9954 1.1%
 
85.7 9890 1.1%
 
95 9681 1.1%
 
92.9 9625 1.1%
 
Other values (639) 360981 41.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 6 < 0.1%
 
5 1 < 0.1%
 
5.9 1 < 0.1%
 
6.7 1 < 0.1%
 
7.1 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 425482 48.5%
 
99.4 2 < 0.1%
 
99.3 1 < 0.1%
 
99.2 4 < 0.1%
 
99.1 8 < 0.1%
 

policy_code
Constant

This variable is constant and should be ignored for analysis

Constant value1

pub_rec
Numeric

Distinct count35
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.2353146861
Minimum0
Maximum61
Zeros (%)81.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum61
Range61
Interquartile range0

Descriptive statistics

Standard deviation0.6390593224
Coef of variation2.715764719
Kurtosis403.2757727
Mean0.2353146861
MAD0.3853422513
Skewness9.445952551
Sum206603
Variance0.4083968176
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=35)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 9.5 11.5 14.5 24.5 61. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 718878 81.9%
 
1 131388 15.0%
 
2 17750 2.0%
 
3 5669 0.6%
 
4 2146 0.2%
 
5 1019 0.1%
 
6 518 0.1%
 
7 240 < 0.1%
 
8 123 < 0.1%
 
9 87 < 0.1%
 
Other values (25) 168 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 718878 81.9%
 
1 131388 15.0%
 
2 17750 2.0%
 
3 5669 0.6%
 
4 2146 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
61 2 < 0.1%
 
47 1 < 0.1%
 
46 1 < 0.1%
 
45 1 < 0.1%
 
44 1 < 0.1%
 

pub_rec_bankruptcies
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1398530273
Minimum0
Maximum9
Zeros (%)87.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.3850018638
Coef of variation2.752903325
Kurtosis17.72890192
Mean0.1398530273
MAD0.2434774899
Skewness3.333164487
Sum122789
Variance0.1482264351
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 5.5 6.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 764266 87.0%
 
1 106867 12.2%
 
2 5303 0.6%
 
3 1102 0.1%
 
4 297 < 0.1%
 
5 103 < 0.1%
 
6 35 < 0.1%
 
7 8 < 0.1%
 
8 4 < 0.1%
 
9 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 764266 87.0%
 
1 106867 12.2%
 
2 5303 0.6%
 
3 1102 0.1%
 
4 297 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 < 0.1%
 
8 4 < 0.1%
 
7 8 < 0.1%
 
6 35 < 0.1%
 
5 103 < 0.1%
 

purpose
Categorical

Distinct count14
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
debt_consolidation
493982
credit_card
183075
home_improvement
 
65875
Other values (11)
135054
ValueCountFrequency (%) 
debt_consolidation 493982 56.3%
 
credit_card 183075 20.9%
 
home_improvement 65875 7.5%
 
other 61526 7.0%
 
major_purchase 21546 2.5%
 
medical 12325 1.4%
 
car 10170 1.2%
 
small_business 9728 1.1%
 
vacation 7288 0.8%
 
moving 6873 0.8%
 
Other values (4) 5598 0.6%
 
Max length18
Mean length14.75631844
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

pymnt_plan
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
n
877310
y
 
676
ValueCountFrequency (%) 
n 877310 99.9%
 
y 676 0.1%
 

recoveries
Highly correlated

This variable is highly correlated with collection_recovery_fee and should be ignored for analysis

Correlation0.9864791705

revol_bal
Numeric

Distinct count76815
Unique (%)8.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean16612.13533
Minimum0
Maximum2559552
Zeros (%)0.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1559
Q15810
Median11036
Q319844
95-th percentile45786
Maximum2559552
Range2559552
Interquartile range14034

Descriptive statistics

Standard deviation23524.60924
Coef of variation1.416109896
Kurtosis369.6307028
Mean16612.13533
MAD11939.00591
Skewness10.84383952
Sum1.458522225e+10
Variance553407239.7
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 1.250000e+01 3.850000e+01 3.950000e+01 ... 4.337060e+05 5.741850e+05 6.700755e+05 1.065937e+06 2.559552e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 4418 0.5%
 
8 98 < 0.1%
 
10 74 < 0.1%
 
5262 73 < 0.1%
 
5453 72 < 0.1%
 
5125 71 < 0.1%
 
2 70 < 0.1%
 
5724 70 < 0.1%
 
5723 69 < 0.1%
 
4327 69 < 0.1%
 
Other values (76805) 872902 99.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4418 0.5%
 
1 39 < 0.1%
 
2 70 < 0.1%
 
3 53 < 0.1%
 
4 57 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2559552 1 < 0.1%
 
1698749 1 < 0.1%
 
1696796 1 < 0.1%
 
1087664 1 < 0.1%
 
1044210 1 < 0.1%
 

sub_grade
Categorical

Distinct count35
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
C1
 
64118
B5
 
62555
C4
 
54134
Other values (32)
697179
ValueCountFrequency (%) 
C1 64118 7.3%
 
B5 62555 7.1%
 
C4 54134 6.2%
 
C2 53682 6.1%
 
C3 52744 6.0%
 
C5 52644 6.0%
 
B4 52436 6.0%
 
B1 52329 6.0%
 
B3 52011 5.9%
 
B2 48308 5.5%
 
Other values (25) 333025 37.9%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

tax_liens
Numeric

Distinct count34
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.06532792095
Minimum0
Maximum61
Zeros (%)96.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum61
Range61
Interquartile range0

Descriptive statistics

Standard deviation0.4409775114
Coef of variation6.750214992
Kurtosis1697.49851
Mean0.06532792095
MAD0.1254597339
Skewness23.34781072
Sum57357
Variance0.1944611656
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=34)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 10.5 11.5 15.5 29.5 61. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 843069 96.0%
 
1 23465 2.7%
 
2 6612 0.8%
 
3 2455 0.3%
 
4 1090 0.1%
 
5 573 0.1%
 
6 289 < 0.1%
 
7 146 < 0.1%
 
8 97 < 0.1%
 
9 55 < 0.1%
 
Other values (24) 135 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 843069 96.0%
 
1 23465 2.7%
 
2 6612 0.8%
 
3 2455 0.3%
 
4 1090 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
61 2 < 0.1%
 
46 1 < 0.1%
 
45 2 < 0.1%
 
44 1 < 0.1%
 
37 1 < 0.1%
 

term
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
36 months
643914
60 months
234072
ValueCountFrequency (%) 
36 months 643914 73.3%
 
60 months 234072 26.7%
 
Max length10
Mean length10
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

tot_coll_amt
Numeric

Distinct count11174
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean249.6479727
Minimum0
Maximum932461
Zeros (%)83.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile942
Maximum932461
Range932461
Interquartile range0

Descriptive statistics

Standard deviation2313.7487
Coef of variation9.268045216
Kurtosis51943.77326
Mean249.6479727
MAD430.3873227
Skewness151.083683
Sum219187425
Variance5353433.045
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 1.000000e+00 9.500000e+00 2.450000e+01 2.550000e+01 ... 5.214000e+04 6.684800e+04 1.195805e+05 2.117700e+05 9.324610e+05], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 729825 83.1%
 
50 1578 0.2%
 
100 1326 0.2%
 
75 1030 0.1%
 
200 848 0.1%
 
150 833 0.1%
 
60 776 0.1%
 
70 587 0.1%
 
80 584 0.1%
 
250 537 0.1%
 
Other values (11164) 140062 16.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 729825 83.1%
 
2 2 < 0.1%
 
5 1 < 0.1%
 
6 2 < 0.1%
 
7 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
932461 1 < 0.1%
 
848438 1 < 0.1%
 
309838 1 < 0.1%
 
262740 1 < 0.1%
 
224107 1 < 0.1%
 

tot_cur_bal
Numeric

Distinct count345595
Unique (%)39.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean144489.7479
Minimum0
Maximum8524709
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile8405
Q129598
Median80675.5
Q3215655
95-th percentile447590.75
Maximum8524709
Range8524709
Interquartile range186057

Descriptive statistics

Standard deviation163040.8928
Coef of variation1.128390734
Kurtosis27.55432988
Mean144489.7479
MAD120051.5081
Skewness2.890798826
Sum1.268599758e+11
Variance2.658233271e+10
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-01 6.0500000e+01 1.4725000e+03 2.6135000e+03 ... 1.6488400e+06 2.1476715e+06 2.5550790e+06 3.7710870e+06 8.5247090e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 258 < 0.1%
 
12794 22 < 0.1%
 
23520 21 < 0.1%
 
25344 21 < 0.1%
 
22373 20 < 0.1%
 
24830 20 < 0.1%
 
16053 20 < 0.1%
 
28171 20 < 0.1%
 
18837 19 < 0.1%
 
20084 19 < 0.1%
 
Other values (345585) 877546 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 258 < 0.1%
 
1 7 < 0.1%
 
2 4 < 0.1%
 
3 7 < 0.1%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8524709 1 < 0.1%
 
5445012 1 < 0.1%
 
5172185 1 < 0.1%
 
4348538 1 < 0.1%
 
4035706 1 < 0.1%
 

tot_hi_cred_lim
Highly correlated

This variable is highly correlated with tot_cur_bal and should be ignored for analysis

Correlation0.972754613

total_acc
Numeric

Distinct count135
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean23.91298836
Minimum2
Maximum176
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q115
Median22
Q330
95-th percentile46
Maximum176
Range174
Interquartile range15

Descriptive statistics

Standard deviation11.95948862
Coef of variation0.5001252224
Kurtosis2.160655547
Mean23.91298836
MAD9.286471479
Skewness1.071604412
Sum20995269
Variance143.0293681
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 2. 2.5 3.5 4.5 5.5 ... 95.5 102.5 112.5 122.5 176. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
20 32534 3.7%
 
18 32445 3.7%
 
19 32366 3.7%
 
17 32079 3.7%
 
21 31992 3.6%
 
16 31849 3.6%
 
22 30842 3.5%
 
15 30754 3.5%
 
23 30424 3.5%
 
14 29719 3.4%
 
Other values (125) 562982 64.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2 508 0.1%
 
3 1685 0.2%
 
4 3882 0.4%
 
5 6346 0.7%
 
6 9505 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
176 1 < 0.1%
 
173 1 < 0.1%
 
165 1 < 0.1%
 
160 1 < 0.1%
 
157 1 < 0.1%
 

total_bal_ex_mort
Numeric

Distinct count166421
Unique (%)19.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean52322.54494
Minimum0
Maximum3408095
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile6702
Q121366
Median38701
Q366090
95-th percentile142814.75
Maximum3408095
Range3408095
Interquartile range44724

Descriptive statistics

Standard deviation50905.60351
Coef of variation0.9729191033
Kurtosis54.70301751
Mean52322.54494
MAD33402.83465
Skewness3.901526222
Sum4.593846194e+10
Variance2591380468
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 6.250000e+01 1.472500e+03 1.951500e+03 ... 6.341540e+05 7.226855e+05 8.960355e+05 1.201214e+06 3.408095e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 485 0.1%
 
27673 30 < 0.1%
 
23915 30 < 0.1%
 
12794 28 < 0.1%
 
18720 28 < 0.1%
 
21641 28 < 0.1%
 
23366 27 < 0.1%
 
24830 27 < 0.1%
 
22702 27 < 0.1%
 
28739 27 < 0.1%
 
Other values (166411) 877249 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 485 0.1%
 
1 11 < 0.1%
 
2 8 < 0.1%
 
3 11 < 0.1%
 
4 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3408095 1 < 0.1%
 
2698600 1 < 0.1%
 
1771306 1 < 0.1%
 
1548128 1 < 0.1%
 
1501187 1 < 0.1%
 

total_bc_limit
Numeric

Distinct count8349
Unique (%)1.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean23277.08784
Minimum0
Maximum1105500
Zeros (%)1.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile2300
Q18400
Median16400
Q330400
95-th percentile67400
Maximum1105500
Range1105500
Interquartile range22000

Descriptive statistics

Standard deviation23079.52043
Coef of variation0.9915123654
Kurtosis21.59122619
Mean23277.08784
MAD15963.72434
Skewness2.900655075
Sum2.043695724e+10
Variance532664263.1
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e+01 1.5000e+02 2.2500e+02 2.7550e+02 ... 2.4665e+05 2.7615e+05 3.3895e+05 4.2260e+05 1.1055e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 10424 1.2%
 
5000 6913 0.8%
 
6000 6163 0.7%
 
10000 6156 0.7%
 
7000 5896 0.7%
 
8000 5779 0.7%
 
4000 5624 0.6%
 
3000 5499 0.6%
 
9000 5430 0.6%
 
7500 5402 0.6%
 
Other values (8339) 814700 92.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 10424 1.2%
 
100 5 < 0.1%
 
200 108 < 0.1%
 
250 2 < 0.1%
 
251 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1105500 1 < 0.1%
 
719500 1 < 0.1%
 
711400 1 < 0.1%
 
616000 1 < 0.1%
 
520500 1 < 0.1%
 

total_il_high_credit_limit
Numeric

Distinct count152973
Unique (%)17.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean45490.25168
Minimum0
Maximum2000000
Zeros (%)10.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q116122
Median34265
Q360960.75
95-th percentile128951
Maximum2000000
Range2000000
Interquartile range44838.75

Descriptive statistics

Standard deviation45931.62248
Coef of variation1.009702536
Kurtosis25.34514141
Mean45490.25168
MAD31569.8116
Skewness3.024418596
Sum3.993980412e+10
Variance2109713944
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 1.800000e+01 2.830000e+02 4.995000e+02 5.005000e+02 ... 5.100310e+05 6.064700e+05 8.042645e+05 1.330168e+06 2.000000e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 94263 10.7%
 
10000 5578 0.6%
 
15000 4432 0.5%
 
20000 3728 0.4%
 
5000 3519 0.4%
 
12000 2868 0.3%
 
25000 2620 0.3%
 
6000 2327 0.3%
 
8000 2270 0.3%
 
7000 1496 0.2%
 
Other values (152963) 754885 86.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 94263 10.7%
 
36 1 < 0.1%
 
44 1 < 0.1%
 
75 1 < 0.1%
 
95 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2000000 1 < 0.1%
 
1736064 1 < 0.1%
 
1349413 1 < 0.1%
 
1310923 1 < 0.1%
 
1285625 1 < 0.1%
 

total_pymnt
Numeric

Distinct count606059
Unique (%)69.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean10444.12374
Minimum0
Maximum59808.26209
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1722.64
Q14416.04
Median7955.52
Q313866.1625
95-th percentile28047.28842
Maximum59808.26209
Range59808.26209
Interquartile range9450.1225

Descriptive statistics

Standard deviation8409.701654
Coef of variation0.8052089255
Kurtosis2.404868468
Mean10444.12374
MAD6363.453108
Skewness1.532553823
Sum9169794425
Variance70723081.91
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 8.29000000e+00 9.92150000e+01 2.48445000e+02 2.99060000e+02 ... 4.89998743e+04 5.04308900e+04 5.22586704e+04 5.51628641e+04 5.98082621e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 392 < 0.1%
 
9031.54 110 < 0.1%
 
3515.31 108 < 0.1%
 
4642.74 96 < 0.1%
 
3127.87 94 < 0.1%
 
3590.61 94 < 0.1%
 
18063.09 92 < 0.1%
 
3646.44 92 < 0.1%
 
3441.1 89 < 0.1%
 
9028.59 88 < 0.1%
 
Other values (606049) 876731 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 392 < 0.1%
 
16.58 1 < 0.1%
 
17.58 1 < 0.1%
 
30.7 1 < 0.1%
 
33.63 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
59808.26209 1 < 0.1%
 
58559.128 1 < 0.1%
 
57459.75603 1 < 0.1%
 
56642.01229 1 < 0.1%
 
56109.34 1 < 0.1%
 

total_pymnt_inv
Highly correlated

This variable is highly correlated with total_pymnt and should be ignored for analysis

Correlation0.9999946425

total_rec_int
Numeric

Distinct count373667
Unique (%)42.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2168.23948
Minimum0
Maximum22644.05
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile202.66
Q1715.9225
Median1470.505
Q32887.845
95-th percentile6455.6475
Maximum22644.05
Range22644.05
Interquartile range2171.9225

Descriptive statistics

Standard deviation2157.487331
Coef of variation0.9950410697
Kurtosis7.160820834
Mean2168.23948
MAD1548.358239
Skewness2.222608116
Sum1903683908
Variance4654751.585
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 4.0000000e-02 3.8500000e-01 1.1950000e+00 ... 1.6771795e+04 1.8346100e+04 1.9041215e+04 2.0831800e+04 2.2644050e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1236 0.1%
 
960.93 123 < 0.1%
 
753.15 107 < 0.1%
 
810.65 102 < 0.1%
 
872.71 98 < 0.1%
 
972.78 94 < 0.1%
 
634.17 92 < 0.1%
 
584.65 92 < 0.1%
 
1621.31 90 < 0.1%
 
1104.51 82 < 0.1%
 
Other values (373657) 875870 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1236 0.1%
 
0.01 16 < 0.1%
 
0.07 2 < 0.1%
 
0.12 1 < 0.1%
 
0.19 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
22644.05 1 < 0.1%
 
22559.92 1 < 0.1%
 
22117.12 1 < 0.1%
 
22088.55 1 < 0.1%
 
21997.72 1 < 0.1%
 

total_rec_late_fee
Numeric

Distinct count7058
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.536038639
Minimum-3.9e-09
Maximum1198.89
Zeros (%)96.2%
Mini histogram

Quantile statistics

Minimum-3.9e-09
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum1198.89
Range1198.89
Interquartile range0

Descriptive statistics

Standard deviation11.85547305
Coef of variation7.718212781
Kurtosis815.3171504
Mean1.536038639
MAD2.954951753
Skewness20.29350981
Sum1348620.42
Variance140.5522413
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-3.90000e-09 -2.00000e-10 1.50000e-10 1.18500e-08 9.57000e+00 ... 2.58480e+02 3.53290e+02 4.82090e+02 7.53495e+02 1.19889e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 844499 96.2%
 
15 8178 0.9%
 
30 1677 0.2%
 
45 548 0.1%
 
60 249 < 0.1%
 
75 124 < 0.1%
 
16.49 72 < 0.1%
 
15.00000001 66 < 0.1%
 
16.61 63 < 0.1%
 
19.78 58 < 0.1%
 
Other values (7048) 22452 2.6%
 

Minimum 5 values

ValueCountFrequency (%) 
-3.9e-09 1 < 0.1%
 
-2e-09 1 < 0.1%
 
-4e-10 1 < 0.1%
 
0 844499 96.2%
 
3e-10 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1198.89 1 < 0.1%
 
1188.83 1 < 0.1%
 
883.31 1 < 0.1%
 
801.6 1 < 0.1%
 
765 1 < 0.1%
 

total_rec_prncp
Highly correlated

This variable is highly correlated with total_pymnt_inv and should be ignored for analysis

Correlation0.9665829516

total_rev_hi_lim
Numeric

Distinct count17911
Unique (%)2.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean34778.91482
Minimum0
Maximum2175000
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile5900
Q114600
Median25500
Q343300
95-th percentile92000
Maximum2175000
Range2175000
Interquartile range28700

Descriptive statistics

Standard deviation35445.19158
Coef of variation1.019157492
Kurtosis99.81228952
Mean34778.91482
MAD21788.39337
Skewness5.771171984
Sum3.05354003e+10
Variance1256361606
Memory size6.7 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e+01 2.500000e+02 3.500000e+02 4.500000e+02 ... 5.736385e+05 6.854500e+05 7.780000e+05 1.165400e+06 2.175000e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
10000 2959 0.3%
 
11000 2734 0.3%
 
14000 2731 0.3%
 
15000 2718 0.3%
 
13000 2711 0.3%
 
11500 2701 0.3%
 
16000 2682 0.3%
 
12000 2681 0.3%
 
12500 2627 0.3%
 
14500 2612 0.3%
 
Other values (17901) 850830 96.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 584 0.1%
 
100 12 < 0.1%
 
200 25 < 0.1%
 
300 140 < 0.1%
 
400 48 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2175000 1 < 0.1%
 
1827401 1 < 0.1%
 
1652700 1 < 0.1%
 
1649101 1 < 0.1%
 
1629000 1 < 0.1%
 

verification_status
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Source Verified
352959
Not Verified
285462
Verified
239565
ValueCountFrequency (%) 
Source Verified 352959 40.2%
 
Not Verified 285462 32.5%
 
Verified 239565 27.3%
 
Max length15
Mean length12.11459978
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

acc_now_delinqacc_open_past_24mthsaddr_stateannual_incapplication_typechargeoff_within_12_mthscollection_recovery_feecollections_12_mths_ex_meddebt_settlement_flagdelinq_2yrsdelinq_amntdf_indexdisbursement_methodearliest_cr_linefico_range_highfico_range_lowfunded_amntfunded_amnt_invgradehardship_flaghome_ownershipinitial_list_statusinstallmentint_rateissue_dlast_fico_range_highlast_fico_range_lowlast_pymnt_amntloan_amntloan_statusmo_sin_old_rev_tl_opmo_sin_rcnt_rev_tl_opmo_sin_rcnt_tlmort_accnum_accts_ever_120_pdnum_actv_bc_tlnum_actv_rev_tlnum_bc_satsnum_bc_tlnum_il_tlnum_op_rev_tlnum_rev_acctsnum_rev_tl_bal_gt_0num_satsnum_tl_30dpdnum_tl_90g_dpd_24mnum_tl_op_past_12mopen_accout_prncpout_prncp_invpct_tl_nvr_dlqpolicy_codepub_recpub_rec_bankruptciespurposepymnt_planrecoveriesrevol_balsub_gradetax_lienstermtot_coll_amttot_cur_baltot_hi_cred_limtotal_acctotal_bal_ex_morttotal_bc_limittotal_il_high_credit_limittotal_pymnttotal_pymnt_invtotal_rec_inttotal_rec_late_feetotal_rec_prncptotal_rev_hi_limverification_status
006IN108329.0Individual00.00000N100CashMar-966996952600026000.0CNRENTw894.8214.49Sep-16669665894.8226000Current24666004856111419821004219968.309968.3089.7100carn0.0012300C4036 months0562831265933056283182009399321523.30000021523.305402.1289.4816031.7032600Not Verified
104FL75000.0Individual00.00000N001CashApr-867997951200012000.0ANMORTGAGEf361.385.32Sep-1680980510533.6012000Fully Paid36513137077121551521720000200.000.00100.0100home_improvementn0.0019897A1036 months024269548600033375841537003900012333.41143012333.41333.410.0012000.00167000Not Verified
208TX56000.0Individual0228.74580Y002CashSep-0367467030003000.0CNMORTGAGEw102.5213.99Sep-16629625102.523000Charged Off133332024225564900390.000.00100.0111debt_consolidationn1270.815466C3036 months09973311292513220322700270251778.7500001778.75162.250.00345.695900Source Verified
303NC110000.0Individual00.00000N003CashOct-7770470080008000.0ANMORTGAGEf249.197.59Sep-16744740284.198000Current467991310131119719401322003222206.312206.3189.6100debt_consolidationn0.0046404A3036 months0257939365263485566456300197636594.6200006594.62800.930.005793.6975500Source Verified
404IL75000.0Individual00.00000N004CashApr-086646601800018000.0CNRENTw423.4214.49Sep-16509505423.4218000Charged Off32550034333444500150.000.0085.7100debt_consolidationn0.006469C4060 months0158032662771580312700128275475.4800005475.482593.620.002881.8613800Not Verified
505CA65000.0Individual00.00000N005CashNov-927047003220032200.0DNMORTGAGEw880.0221.49Sep-1673473031447.6032200Fully Paid28633303551071424517002170.000.00100.0111credit_cardn0.0011987D5060 months01735131999693424934139001588635770.81275035770.813570.810.0032200.0024900Not Verified
603OR35000.0Individual00.00000N006CashSep-0977477026002600.0BNRENTw82.678.99Sep-167647602492.062600Fully Paid61131300456814710514000140.000.00100.0100movingn0.00720B1036 months01949773227241949750200205272662.5902382662.5962.590.002600.0052700Source Verified
707OK65000.0Individual00.00000N007CashJul-0470970510001000.0CNOWNw33.9413.49Sep-16699695820.221000Fully Paid1464420335686113900490.000.00100.0100othern0.0012501C2036 months78109761131469212356829100130001090.2439211090.2490.240.001000.0030100Verified
8011OR60000.0Individual00.00000N208CashSep-986996951200012000.0DNMORTGAGEw311.2318.99Sep-1671471012107.0912000Fully Paid2164181285961723819029190.000.0078.4100major_purchasen0.007935D3060 months02724392906713743438110003538612704.23287012704.23704.230.0012000.0021600Not Verified
908IL95000.0Individual00.00000N009CashMay-9367467080008000.0CNMORTGAGEw268.7512.79Sep-16644640268.758000Current2806230384681019812007123023.533023.5396.4111debt_consolidationn0.0011343C1036 months03070544176303070515000204766446.6800006446.681470.210.004976.4723700Verified

Last rows

acc_now_delinqacc_open_past_24mthsaddr_stateannual_incapplication_typechargeoff_within_12_mthscollection_recovery_feecollections_12_mths_ex_meddebt_settlement_flagdelinq_2yrsdelinq_amntdf_indexdisbursement_methodearliest_cr_linefico_range_highfico_range_lowfunded_amntfunded_amnt_invgradehardship_flaghome_ownershipinitial_list_statusinstallmentint_rateissue_dlast_fico_range_highlast_fico_range_lowlast_pymnt_amntloan_amntloan_statusmo_sin_old_rev_tl_opmo_sin_rcnt_rev_tl_opmo_sin_rcnt_tlmort_accnum_accts_ever_120_pdnum_actv_bc_tlnum_actv_rev_tlnum_bc_satsnum_bc_tlnum_il_tlnum_op_rev_tlnum_rev_acctsnum_rev_tl_bal_gt_0num_satsnum_tl_30dpdnum_tl_90g_dpd_24mnum_tl_op_past_12mopen_accout_prncpout_prncp_invpct_tl_nvr_dlqpolicy_codepub_recpub_rec_bankruptciespurposepymnt_planrecoveriesrevol_balsub_gradetax_lienstermtot_coll_amttot_cur_baltot_hi_cred_limtotal_acctotal_bal_ex_morttotal_bc_limittotal_il_high_credit_limittotal_pymnttotal_pymnt_invtotal_rec_inttotal_rec_late_feetotal_rec_prncptotal_rev_hi_limverification_status
87797604OR60000.0Individual00.00000N1097844CashJun-976846801960019600.0BNMORTGAGEw430.7611.47Apr-16689685430.7619600Current225242350677102410207140001411188.9911188.9998.0100debt_consolidationn0.0022358B5060 months02283582800014976160175007284112979.00000012979.004567.990.08411.0129700Not Verified
87797705CA139000.0Individual0511.00740N0097845CashOct-036646602800028000.0GNMORTGAGEw883.1628.67Apr-16674670883.1628000Charged Off86951323255593800380.000.0078.6100credit_cardn2838.933777G4060 months134531557735933915128115500013078210742.77000010742.775781.230.02122.6121700Not Verified
87797809VA59000.0Individual00.00000N0097846CashAug-937097052240022400.0GNRENTw702.0528.34Apr-16694690702.0522400Current27144002112911142911160071615308.9715308.97100.0100debt_consolidationn0.0093022G3060 months012196314749640121963101004299620324.18000020324.1813233.150.07091.03104500Source Verified
87797908NY57900.0Individual00.00000N0097847CashNov-056746701335013350.0GNRENTw418.4128.34Apr-16559555418.4113350Current91880059710161317924003249142.769142.7671.0100debt_consolidationn0.009762G3060 months093545887503393545113006795012222.02000012222.028014.780.04207.2420800Not Verified
87798004PA67000.0Individual00.00000N6097848CashApr-9166966550005000.0BNOWNw157.598.39Apr-16654650157.595000Current29922106781112142371600116922.55922.5568.6100debt_consolidationn0.0010524B1036 months1702702963658362702929800274584725.3700004725.37647.920.04077.4536200Not Verified
87798106IN45000.0Individual00.00000N0097849CashApr-8468968570007000.0ANMORTGAGEw210.815.32Apr-16709705210.817000Current383166323531258265900291449.881449.8868.6100debt_consolidationn0.005307A1036 months07219680800355307970006122.7900006122.79572.670.05550.1213600Source Verified
87798208IN48000.0Individual00.00000N0097850CashJul-046996952147521475.0DNMORTGAGEw536.8417.27Apr-16544540536.8421475Charged Off1403310558981518517003170.000.00100.0111debt_consolidationn0.0017496D2060 months0135850180325274664527800450258548.2300008548.234482.690.04065.5437100Source Verified
87798301OH50000.0Individual00.00000N1097851CashSep-0068468060506050.0DNMORTGAGEw154.4618.25Apr-167097054878.636050Fully Paid186882012202020120312121001220.000.0097.0100credit_cardn0.0034947D3060 months015448017139734376192225007646.6418277646.641596.640.06050.0038950Source Verified
87798407LA591000.0Individual00.00000N0097852CashSep-957547503000030000.0DNMORTGAGEw778.0618.99Apr-16539535778.0630000Charged Off2461131114622915215005150.000.0097.3100debt_consolidationn0.0055154D4060 months010913916869840109139541006109815650.90000015650.908580.010.07070.89107600Not Verified
87798502IN52000.0Individual00.00000N0097853CashAug-0266966550005000.0BNMORTGAGEw163.1110.75Apr-16764760163.115000Current16333103434057460016948.38948.38100.0121credit_cardn0.003979B4036 months144514221116120083979520004890.3100004890.31838.690.04051.626200Not Verified